--ready
USE [whydb2012]
GO

DECLARE	@return_value int

EXEC	@return_value = [whydb2012].[P_Ready]
		@UserID = N'test1',
		@RoomGUID = '35F6DDE4-ED96-4D75-9262-23704DE0BE0E',
		@operatortime = '2012-2-25'

SELECT	'Return Value' = @return_value

GO


--sit
USE [whydb2012]
GO

DECLARE	@return_value int

EXEC	@return_value = [whydb2012].[P_Sit]
		@UserID = N'test1',
		@SeatID = 3,
		@RoomGUID = '35F6DDE4-ED96-4D75-9262-23704DE0BE0E',
		@operatortime = '2012-2-25'

SELECT	'Return Value' = @return_value

GO

--stand
USE [whydb2012]
GO

DECLARE	@return_value int

EXEC	@return_value = [whydb2012].[P_Stand]
		@UserID = N'test1',
		@RoomGUID = '35F6DDE4-ED96-4D75-9262-23704DE0BE0E',
		@operatortime = '2012-2-25'

SELECT	'Return Value' = @return_value

GO

--
select * from tb_room

select * from TB_USER_ROOM_MAP

select * from whydb2012.TB_PLAY_RECORD


select * from tb_userinfo
